[QUIZ] Test your understanding of SQL - Part 1
- Question 1: What does SQL mean?
- Structured Question Language
- Structured Query Language
- Strong Question Language
-
- Question 2: Which SQL statement is used to retrieve data from the database?
- GET
- OPEN
- SELECT
- EXTRACT
-
- Question 3: Which SQL statement is used to update data in the database?
- MODIFY
- SAVE AS
- SAVE
- UPDATE
-
- Question 4: Which SQL statement is used to delete data from the database?
- REMOVE
- DELETE
- COLLAPSE
- DROP
-
- Question 5: Which SQL statement is used to add new data to the database?
- ADD RECORD
- ADD NEW
- INSERT INTO
- NEW INSERT
-
- Question 6: In SQL, how to select a column named "FirstName" from the "Persons" table?
- EXTRACT FirstName FROM Persons
- SELECT FirstName FROM Persons
- SELECT Persons.FirstName
-
- Question 7: In SQL, how to select all columns from the "Persons" table?
- SELECT [all] FROM Persons
- SELECT * FROM Persons
- SELECT * .Persons
- SELECT Persons
-
- Question 8: In SQL, how to select all records from the "Persons" table in which the value of "FirstName" column is "Peter"?
- SELECT [all] FROM Persons WHERE FirstName = 'Peter'
- SELECT [all] FROM Persons WHERE FirstName LIKE 'Peter'
- SELECT * FROM Persons WHERE FirstName <> 'Peter'
- SELECT * FROM Persons WHERE FirstName = 'Peter'
-
- Question 9: In SQL, how to select all records from the "Persons" table in which the value of the "FirstName" column begins with "a"?
- SELECT * FROM Persons WHERE FirstName LIKE '% a'
- SELECT * FROM Persons WHERE FirstName LIKE 'a%'
- SELECT * FROM Persons WHERE FirstName = '% a%'
- SELECT * FROM Persons WHERE FirstName = 'a'
-
- Question 10: The OR operator displays a record if the retrieved data only needs to satisfy one of the listed conditions. The AND operator displays the record if the retrieved data satisfies all the listed conditions.
- It's correct
- False
-
- Question 11: In SQL, how to select all records from the "Persons" table in which the value of the "FirstName" column is "Peter" and "LastName" is "Jackson"?
- SELECT * FROM Persons WHERE FirstName = 'Peter' AND LastName = 'Jackson'
- SELECT * FROM Persons WHERE FirstName <> 'Peter' AND LastName <> 'Jackson'
- SELECT FirstName = 'Peter', LastName = 'Jackson' FROM Persons
-
- Question 12: In SQL, how to select all records from the "Persons" table in which "LastName" is sorted alphabetically and is in "Hansen" and "Pettersen" (including 2 values). this)
- SELECT * FROM Persons WHERE LastName> 'Hansen' AND LastName <'Pettersen'
- SELECT LastName> 'Hansen' AND LastName <'Pettersen' FROM Persons
- SELECT * FROM Persons WHERE LastName BETWEEN 'Hansen' AND 'Pettersen'
-
- Question 13: Which SQL statement is used to return unique values in the table?
- SELECT UNIQUE
- SELECT DISTINCT
- SELECT DIFFERENT
-
- Question 14: Which SQL command is used to sort the result set?
- SORT BY
- SORT
- ORDER
- ORDER BY
-
- Question 15: In SQL, how can I return all records from the "Persons" table sorted in descending order according to "FirstName"?
- SELECT * FROM Persons SORT BY 'FirstName' DESC
- SELECT * FROM Persons ORDER BY FirstName DESC
- SELECT * FROM Persons SORT 'FirstName' DESC
- SELECT * FROM Persons ORDER FirstName DESC
-
5 ★ | 1 Vote
You should read it
- [QUIZ] Test your understanding of SQL - Part 5
- [QUIZ] Test your understanding of SQL - Part 6
- [QUIZ] Test your understanding of SQL - Part 7
- [QUIZ] Check your understanding of SQL - Part 2
- Test about database security P8
- What do you know about NoSQL Database?
- eQuiz - Multiple choice test on SQL
- Test about database security P12
May be interested
- Multiple choice quiz about Python - Part 10following the previous test, part 10 returned with the python function. let's try with quantrimang to try the 10 questions below.
- eQuiz - Quiz on Core Java - Part 1in the quiz below, you will be able to challenge the most basic questions related to core java - one of the most popular programming languages today.
- Excel computer test - Part 3after the second part of the excel test, the network administrator will continue to send you the 3rd part of the quiz series on this topic. let's work together to test your knowledge.
- eQuiz - Multiple choice test on PHP Practice - part 1in the quiz below, we will introduce you to part 1 of the test series of basic knowledge about php practive with 15 questions.
- Test your level of understanding of Office 2010 - Part 1in the article below, the network administrator will send you to read interesting quiz questions about office so you can assess your level of understanding about this software.
- eQuiz - Multiple choice test on programming language C - part 1this is part 1 of a series of tests on knowledge of c programming language, in total there will be 15 questions with no time for answering each sentence.
- The test has a Word answer - Part 7below is part 7 of the word quiz series. hopefully, these quizzes will help you partially test your knowledge for a long time.
- Multiple choice quiz about Python - Part 7following the previous test set, part 7 continues with the topic built-in functions in python. let's try with quantrimang to try the 10 questions below.
- Multiple choice quiz about Python - Part 5if you are interested in learning about the python programming language, the following quiz of network administrator will provide useful knowledge for your learning.
- Testing computer science knowledge, doing little for fun (part 2)the series of computer science quiz questions covers many areas with a set of 4 answers and answers at the bottom of the page. after part 1, network administrator continues to introduce part 2.